Release 10.1A: OpenEdge Development:
Basic Database Tools

Field Triggers

Choose Triggers from the Field Editor to define ASSIGN trigger programs for the field. ASSIGN triggers execute when you assign a value to a database field. When you choose Triggers, a Field Triggers dialog box similar to the one shown in Figure 9–9 appears.

Figure 9–9: Field Triggers dialog box

The Field Triggers dialog box contains the following fields:

For ASSIGN

Specifies the name of the trigger procedure. If you want to create or edit the procedure, press PUT and a trigger editor appears.

Overridable?

Specifies whether a session trigger can override the schema trigger. The default value is no. For more information about session and schema triggers, the chapter on database triggers in OpenEdge Development: Progress 4GL Handbook .

Check CRC?

Specifies whether the database engine verifies the cyclical redundancy check (CRC) code. The default value is yes. When the database engine checks the code, it compares the stored CRC value of the procedure to the CRC of the trigger when it fires. If they are different, the database engine does not run the procedure. This ensures that no one changes the trigger code without proper permission.